package com.example.demo.mapper;

import com.example.demo.domain.BudgetActual;
import com.example.demo.domain.BudgetType;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface BudgetActualMapper {

    List<BudgetActual> getAllCost(@Param("type") String type, @Param("month") int month);

    List<BudgetActual> getCostSum(@Param("type") String type, @Param("month") int month);

    BudgetActual getActualMonth(@Param("id")int id);

    List<BudgetActual> getResult(@Param("type") String type);

    List<BudgetActual> getDataList(@Param("type") String type);

    int saveTarget(BudgetActual budgetActual);

    int saveActual(BudgetActual budgetActual);

    int insertType(BudgetType budgetType);

    int updateTarget(BudgetActual budgetActual);

    int updateActual(BudgetActual budgetActual);

    List<BudgetActual> getTarget(@Param("type") String type, @Param("month") int month);

    int delTarget(@Param("id") int id);
}
